Troys Profiling Report

Dataset statistics

Number of variables	18
Number of observations	3315
Missing cells	25432
Missing cells (%)	42.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	466.3 KiB
Average record size in memory	144.0 B

Variable types

Categorical	4
Numeric	14

Warnings

`name` has a high cardinality: 51 distinct values	High cardinality
`abbreviation` has a high cardinality: 51 distinct values	High cardinality
`as_of_date` has a high cardinality: 353 distinct values	High cardinality
`notes` has a high cardinality: 597 distinct values	High cardinality
`staff_tests` is highly correlated with `total_staff_cases` and 4 other fields	High correlation
`staff_tests_with_multiples` is highly correlated with `total_staff_cases` and 10 other fields	High correlation
`total_staff_cases` is highly correlated with `staff_tests` and 12 other fields	High correlation
`staff_recovered` is highly correlated with `staff_tests_with_multiples` and 11 other fields	High correlation
`total_staff_deaths` is highly correlated with `staff_tests_with_multiples` and 10 other fields	High correlation
`staff_partial_dose` is highly correlated with `staff_tests_with_multiples` and 11 other fields	High correlation
`staff_full_dose` is highly correlated with `staff_tests` and 12 other fields	High correlation
`prisoner_tests` is highly correlated with `staff_tests` and 12 other fields	High correlation
`prisoner_tests_with_multiples` is highly correlated with `staff_tests_with_multiples` and 10 other fields	High correlation
`total_prisoner_cases` is highly correlated with `staff_tests` and 12 other fields	High correlation
`prisoners_recovered` is highly correlated with `staff_tests` and 12 other fields	High correlation
`total_prisoner_deaths` is highly correlated with `staff_tests_with_multiples` and 11 other fields	High correlation
`prisoners_partial_dose` is highly correlated with `total_staff_cases` and 9 other fields	High correlation
`prisoners_full_dose` is highly correlated with `staff_tests_with_multiples` and 10 other fields	High correlation
`staff_tests` is highly correlated with `staff_tests_with_multiples` and 7 other fields	High correlation
`staff_tests_with_multiples` is highly correlated with `staff_tests` and 10 other fields	High correlation
`total_staff_cases` is highly correlated with `staff_tests` and 9 other fields	High correlation
`staff_recovered` is highly correlated with `staff_tests` and 9 other fields	High correlation
`total_staff_deaths` is highly correlated with `staff_tests_with_multiples` and 7 other fields	High correlation
`staff_partial_dose` is highly correlated with `staff_tests_with_multiples` and 7 other fields	High correlation
`staff_full_dose` is highly correlated with `staff_tests_with_multiples` and 4 other fields	High correlation
`prisoner_tests` is highly correlated with `staff_tests` and 12 other fields	High correlation
`prisoner_tests_with_multiples` is highly correlated with `staff_tests` and 9 other fields	High correlation
`total_prisoner_cases` is highly correlated with `staff_tests` and 8 other fields	High correlation
`prisoners_recovered` is highly correlated with `staff_tests` and 8 other fields	High correlation
`total_prisoner_deaths` is highly correlated with `staff_tests` and 8 other fields	High correlation
`prisoners_partial_dose` is highly correlated with `staff_partial_dose` and 3 other fields	High correlation
`prisoners_full_dose` is highly correlated with `staff_partial_dose` and 3 other fields	High correlation
`staff_tests` is highly correlated with `staff_tests_with_multiples` and 7 other fields	High correlation
`staff_tests_with_multiples` is highly correlated with `staff_tests` and 7 other fields	High correlation
`total_staff_cases` is highly correlated with `staff_tests` and 8 other fields	High correlation
`staff_recovered` is highly correlated with `staff_tests` and 8 other fields	High correlation
`total_staff_deaths` is highly correlated with `total_staff_cases` and 4 other fields	High correlation
`staff_partial_dose` is highly correlated with `staff_full_dose` and 3 other fields	High correlation
`staff_full_dose` is highly correlated with `staff_partial_dose` and 3 other fields	High correlation
`prisoner_tests` is highly correlated with `staff_tests` and 11 other fields	High correlation
`prisoner_tests_with_multiples` is highly correlated with `staff_tests` and 7 other fields	High correlation
`total_prisoner_cases` is highly correlated with `staff_tests` and 8 other fields	High correlation
`prisoners_recovered` is highly correlated with `staff_tests` and 8 other fields	High correlation
`total_prisoner_deaths` is highly correlated with `staff_tests` and 8 other fields	High correlation
`prisoners_partial_dose` is highly correlated with `staff_partial_dose` and 3 other fields	High correlation
`prisoners_full_dose` is highly correlated with `staff_partial_dose` and 3 other fields	High correlation
`staff_tests_with_multiples` is highly correlated with `staff_recovered` and 13 other fields	High correlation
`staff_recovered` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`name` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`prisoner_tests` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`staff_full_dose` is highly correlated with `staff_tests_with_multiples` and 13 other fields	High correlation
`prisoners_full_dose` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`staff_tests` is highly correlated with `staff_recovered` and 10 other fields	High correlation
`prisoners_recovered` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`total_prisoner_cases` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`total_prisoner_deaths` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`prisoner_tests_with_multiples` is highly correlated with `staff_tests_with_multiples` and 13 other fields	High correlation
`prisoners_partial_dose` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`total_staff_deaths` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`staff_partial_dose` is highly correlated with `staff_tests_with_multiples` and 13 other fields	High correlation
`total_staff_cases` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`abbreviation` is highly correlated with `staff_tests_with_multiples` and 14 other fields	High correlation
`name` is highly correlated with `abbreviation`	High correlation
`abbreviation` is highly correlated with `name`	High correlation
`staff_tests` has 2925 (88.2%) missing values	Missing
`staff_tests_with_multiples` has 2657 (80.2%) missing values	Missing
`total_staff_cases` has 284 (8.6%) missing values	Missing
`staff_recovered` has 1253 (37.8%) missing values	Missing
`total_staff_deaths` has 500 (15.1%) missing values	Missing
`staff_partial_dose` has 2732 (82.4%) missing values	Missing
`staff_full_dose` has 2832 (85.4%) missing values	Missing
`prisoner_tests` has 2002 (60.4%) missing values	Missing
`prisoner_tests_with_multiples` has 1723 (52.0%) missing values	Missing
`total_prisoner_cases` has 143 (4.3%) missing values	Missing
`prisoners_recovered` has 1072 (32.3%) missing values	Missing
`total_prisoner_deaths` has 131 (4.0%) missing values	Missing
`prisoners_partial_dose` has 2523 (76.1%) missing values	Missing
`prisoners_full_dose` has 2625 (79.2%) missing values	Missing
`notes` has 2002 (60.4%) missing values	Missing
`name` is uniformly distributed	Uniform
`abbreviation` is uniformly distributed	Uniform
`total_staff_cases` has 60 (1.8%) zeros	Zeros
`total_staff_deaths` has 1396 (42.1%) zeros	Zeros
`staff_partial_dose` has 161 (4.9%) zeros	Zeros
`staff_full_dose` has 198 (6.0%) zeros	Zeros
`total_prisoner_cases` has 164 (4.9%) zeros	Zeros
`prisoners_recovered` has 44 (1.3%) zeros	Zeros
`total_prisoner_deaths` has 715 (21.6%) zeros	Zeros
`prisoners_partial_dose` has 283 (8.5%) zeros	Zeros
`prisoners_full_dose` has 339 (10.2%) zeros	Zeros

Reproduction

Analysis started	2021-06-30 19:34:53.198555
Analysis finished	2021-06-30 19:35:12.709100
Duration	19.51 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION
UNIFORM

Distinct	51
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

Pennsylvania	65
Missouri	65
Nevada	65
Hawaii	65
Alabama	65
Other values (46)	2990

Length

Max length	14
Median length	8
Mean length	8.411764706
Min length	4

Characters and Unicode

Total characters	27885
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Alabama
2nd row	Alaska
3rd row	Arizona
4th row	Arkansas
5th row	California

Common Values

Value	Count	Frequency (%)
Pennsylvania	65	2.0%
Missouri	65	2.0%
Nevada	65	2.0%
Hawaii	65	2.0%
Alabama	65	2.0%
California	65	2.0%
Oregon	65	2.0%
Massachusetts	65	2.0%
Illinois	65	2.0%
North Carolina	65	2.0%
Other values (41)	2665	80.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	260	6.6%
carolina	130	3.3%
south	130	3.3%
north	130	3.3%
virginia	130	3.3%
dakota	130	3.3%
colorado	65	1.6%
vermont	65	1.6%
mexico	65	1.6%
nevada	65	1.6%
Other values (43)	2795	70.5%

Most occurring characters

Value	Count	Frequency (%)
a	3770	13.5%
i	2535	9.1%
n	2275	8.2%
o	2145	7.7%
s	1950	7.0%
e	1950	7.0%
r	1430	5.1%
t	1105	4.0%
l	975	3.5%
h	845	3.0%
Other values (36)	8905	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	23270	83.4%
Uppercase Letter	3965	14.2%
Space Separator	650	2.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	3770	16.2%
i	2535	10.9%
n	2275	9.8%
o	2145	9.2%
s	1950	8.4%
e	1950	8.4%
r	1430	6.1%
t	1105	4.7%
l	975	4.2%
h	845	3.6%
Other values (14)	4290	18.4%

Uppercase Letter

Value	Count	Frequency (%)
M	585	14.8%
N	520	13.1%
C	325	8.2%
I	325	8.2%
A	260	6.6%
W	260	6.6%
D	195	4.9%
O	195	4.9%
V	195	4.9%
F	130	3.3%
Other values (11)	975	24.6%

Space Separator

Value	Count	Frequency (%)
	650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27235	97.7%
Common	650	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	3770	13.8%
i	2535	9.3%
n	2275	8.4%
o	2145	7.9%
s	1950	7.2%
e	1950	7.2%
r	1430	5.3%
t	1105	4.1%
l	975	3.6%
h	845	3.1%
Other values (35)	8255	30.3%

Common

Value	Count	Frequency (%)
	650	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27885	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	3770	13.5%
i	2535	9.1%
n	2275	8.2%
o	2145	7.7%
s	1950	7.0%
e	1950	7.0%
r	1430	5.1%
t	1105	4.0%
l	975	3.5%
h	845	3.0%
Other values (36)	8905	31.9%

abbreviation
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION
UNIFORM

Distinct	51
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	26.0 KiB

IL	65
MD	65
CO	65
LA	65
DE	65
Other values (46)	2990

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	6630
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AL
2nd row	AK
3rd row	AZ
4th row	AR
5th row	CA

Common Values

Value	Count	Frequency (%)
IL	65	2.0%
MD	65	2.0%
CO	65	2.0%
LA	65	2.0%
DE	65	2.0%
GA	65	2.0%
ME	65	2.0%
OH	65	2.0%
MA	65	2.0%
NE	65	2.0%
Other values (41)	2665	80.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ut	65	2.0%
wi	65	2.0%
ct	65	2.0%
ny	65	2.0%
ky	65	2.0%
ks	65	2.0%
la	65	2.0%
md	65	2.0%
nh	65	2.0%
de	65	2.0%
Other values (41)	2665	80.4%

Most occurring characters

Value	Count	Frequency (%)
A	780	11.8%
N	715	10.8%
M	585	8.8%
I	520	7.8%
T	390	5.9%
C	325	4.9%
O	325	4.9%
D	325	4.9%
S	325	4.9%
L	260	3.9%
Other values (14)	2080	31.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6630	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	780	11.8%
N	715	10.8%
M	585	8.8%
I	520	7.8%
T	390	5.9%
C	325	4.9%
O	325	4.9%
D	325	4.9%
S	325	4.9%
L	260	3.9%
Other values (14)	2080	31.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6630	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	780	11.8%
N	715	10.8%
M	585	8.8%
I	520	7.8%
T	390	5.9%
C	325	4.9%
O	325	4.9%
D	325	4.9%
S	325	4.9%
L	260	3.9%
Other values (14)	2080	31.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6630	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	780	11.8%
N	715	10.8%
M	585	8.8%
I	520	7.8%
T	390	5.9%
C	325	4.9%
O	325	4.9%
D	325	4.9%
S	325	4.9%
L	260	3.9%
Other values (14)	2080	31.4%

staff_tests
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	315
Distinct (%)	80.8%
Missing	2925
Missing (%)	88.2%
Infinite	0
Infinite (%)	0.0%
Mean	1747.961538

Minimum	0
Maximum	14297
Zeros	5
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	16.9
Q1	251.25
median	1023.5
Q3	2398.25
95-th percentile	5983.65
Maximum	14297
Range	14297
Interquartile range (IQR)	2147

Descriptive statistics

Standard deviation	2083.745365
Coefficient of variation (CV)	1.192100237
Kurtosis	6.11604026
Mean	1747.961538
Median Absolute Deviation (MAD)	934.5
Skewness	2.13268807
Sum	681705
Variance	4341994.747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4865	7	0.2%
250	7	0.2%
0	5	0.2%
1030	4	0.1%
571	4	0.1%
464	4	0.1%
10	3	0.1%
2248	3	0.1%
1147	3	0.1%
64	3	0.1%
Other values (305)	347	10.5%
(Missing)	2925	88.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	0.2%
1	2	0.1%
2	1	< 0.1%
6	1	< 0.1%
7	2	0.1%
8	1	< 0.1%
10	3	0.1%
12	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%

Value	Count	Frequency (%)
14297	1	< 0.1%
12448	1	< 0.1%
10601	1	< 0.1%
9245	1	< 0.1%
8728	1	< 0.1%
8393	1	< 0.1%
8020	1	< 0.1%
7525	2	0.1%
6826	1	< 0.1%
6481	1	< 0.1%

staff_tests_with_multiples
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	609
Distinct (%)	92.6%
Missing	2657
Missing (%)	80.2%
Infinite	0
Infinite (%)	0.0%
Mean	43640.10182

Minimum	89
Maximum	278704
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	89
5-th percentile	421.85
Q1	4905
median	12962.5
Q3	58968
95-th percentile	195841.05
Maximum	278704
Range	278615
Interquartile range (IQR)	54063

Descriptive statistics

Standard deviation	62817.01126
Coefficient of variation (CV)	1.439433196
Kurtosis	2.461072836
Mean	43640.10182
Median Absolute Deviation (MAD)	11327
Skewness	1.824615741
Sum	28715187
Variance	3945976904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4905	7	0.2%
573	6	0.2%
464	5	0.2%
7643	5	0.2%
424	4	0.1%
17286	4	0.1%
21766	3	0.1%
13002	2	0.1%
409	2	0.1%
36490	2	0.1%
Other values (599)	618	18.6%
(Missing)	2657	80.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
89	1	< 0.1%
142	1	< 0.1%
159	1	< 0.1%
177	1	< 0.1%
194	1	< 0.1%
198	2	0.1%
282	1	< 0.1%
298	1	< 0.1%
321	1	< 0.1%
345	1	< 0.1%

Value	Count	Frequency (%)
278704	1	< 0.1%
275701	1	< 0.1%
264287	1	< 0.1%
258572	1	< 0.1%
256100	1	< 0.1%
253406	1	< 0.1%
247353	1	< 0.1%
246868	1	< 0.1%
246155	1	< 0.1%
242943	1	< 0.1%

total_staff_cases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	1480
Distinct (%)	48.8%
Missing	284
Missing (%)	8.6%
Infinite	0
Infinite (%)	0.0%
Mean	1096.181788

Minimum	0
Maximum	17002
Zeros	60
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	92
median	377
Q3	1119
95-th percentile	4603.5
Maximum	17002
Range	17002
Interquartile range (IQR)	1027

Descriptive statistics

Standard deviation	2031.927873
Coefficient of variation (CV)	1.853641335
Kurtosis	23.02790925
Mean	1096.181788
Median Absolute Deviation (MAD)	360
Skewness	4.226232458
Sum	3322527
Variance	4128730.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60	1.8%
1	52	1.6%
11	41	1.2%
4	37	1.1%
3	32	1.0%
5	22	0.7%
2	22	0.7%
9	19	0.6%
16	17	0.5%
20	17	0.5%
Other values (1470)	2712	81.8%
(Missing)	284	8.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	60	1.8%
1	52	1.6%
2	22	0.7%
3	32	1.0%
4	37	1.1%
5	22	0.7%
6	8	0.2%
7	9	0.3%
8	16	0.5%
9	19	0.6%

Value	Count	Frequency (%)
17002	1	< 0.1%
16815	1	< 0.1%
16770	1	< 0.1%
16537	1	< 0.1%
16485	1	< 0.1%
16441	1	< 0.1%
16384	1	< 0.1%
16323	1	< 0.1%
16284	1	< 0.1%
16037	1	< 0.1%

staff_recovered
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1189
Distinct (%)	57.7%
Missing	1253
Missing (%)	37.8%
Infinite	0
Infinite (%)	0.0%
Mean	1205.332687

Minimum	0
Maximum	16941
Zeros	22
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	9
Q1	131.25
median	435
Q3	1253.75
95-th percentile	4806.95
Maximum	16941
Range	16941
Interquartile range (IQR)	1122.5

Descriptive statistics

Standard deviation	2175.448181
Coefficient of variation (CV)	1.804852888
Kurtosis	20.02524583
Mean	1205.332687
Median Absolute Deviation (MAD)	388
Skewness	3.998374801
Sum	2485396
Variance	4732574.789
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	28	0.8%
4	25	0.8%
0	22	0.7%
1	19	0.6%
5	15	0.5%
19	10	0.3%
396	10	0.3%
12	10	0.3%
191	10	0.3%
27	9	0.3%
Other values (1179)	1904	57.4%
(Missing)	1253	37.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22	0.7%
1	19	0.6%
2	5	0.2%
3	7	0.2%
4	25	0.8%
5	15	0.5%
6	2	0.1%
7	2	0.1%
8	6	0.2%
9	4	0.1%

Value	Count	Frequency (%)
16941	1	< 0.1%
16694	1	< 0.1%
16611	1	< 0.1%
16403	1	< 0.1%
16331	1	< 0.1%
16261	1	< 0.1%
16201	1	< 0.1%
16137	1	< 0.1%
16084	1	< 0.1%
15706	1	< 0.1%

total_staff_deaths
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	38
Distinct (%)	1.3%
Missing	500
Missing (%)	15.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.328241563

Minimum	0
Maximum	48
Zeros	1396
Zeros (%)	42.1%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	3
95-th percentile	9
Maximum	48
Range	48
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.244169768
Coefficient of variation (CV)	2.252416524
Kurtosis	34.02607846
Mean	2.328241563
Median Absolute Deviation (MAD)	1
Skewness	5.247781437
Sum	6554
Variance	27.50131656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0	1396	42.1%
1	366	11.0%
2	311	9.4%
4	160	4.8%
3	158	4.8%
5	155	4.7%
6	78	2.4%
10	31	0.9%
8	26	0.8%
7	22	0.7%
Other values (28)	112	3.4%
(Missing)	500	15.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1396	42.1%
1	366	11.0%
2	311	9.4%
3	158	4.8%
4	160	4.8%
5	155	4.7%
6	78	2.4%
7	22	0.7%
8	26	0.8%
9	21	0.6%

Value	Count	Frequency (%)
48	3	0.1%
47	1	< 0.1%
46	5	0.2%
45	2	0.1%
44	1	< 0.1%
43	3	0.1%
41	2	0.1%
40	1	< 0.1%
38	1	< 0.1%
37	2	0.1%

staff_partial_dose
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	301
Distinct (%)	51.6%
Missing	2732
Missing (%)	82.4%
Infinite	0
Infinite (%)	0.0%
Mean	2847.586621

Minimum	0
Maximum	35115
Zeros	161
Zeros (%)	4.9%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1049
Q3	3126.5
95-th percentile	11852.7
Maximum	35115
Range	35115
Interquartile range (IQR)	3126.5

Descriptive statistics

Standard deviation	5500.532338
Coefficient of variation (CV)	1.931647065
Kurtosis	15.02727724
Mean	2847.586621
Median Absolute Deviation (MAD)	1049
Skewness	3.708219643
Sum	1660143
Variance	30255856
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	161	4.9%
2697	11	0.3%
1208	10	0.3%
834	9	0.3%
4011	9	0.3%
22	8	0.2%
1517	8	0.2%
249	7	0.2%
7546	6	0.2%
224	6	0.2%
Other values (291)	348	10.5%
(Missing)	2732	82.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	161	4.9%
4	1	< 0.1%
16	1	< 0.1%
22	8	0.2%
30	1	< 0.1%
46	1	< 0.1%
50	1	< 0.1%
100	1	< 0.1%
107	1	< 0.1%
113	2	0.1%

Value	Count	Frequency (%)
35115	1	< 0.1%
34837	1	< 0.1%
33259	1	< 0.1%
33231	1	< 0.1%
32025	1	< 0.1%
31642	1	< 0.1%
27968	1	< 0.1%
27844	1	< 0.1%
27806	1	< 0.1%
27539	1	< 0.1%

staff_full_dose
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	199
Distinct (%)	41.2%
Missing	2832
Missing (%)	85.4%
Infinite	0
Infinite (%)	0.0%
Mean	2660.146998

Minimum	0
Maximum	33060
Zeros	198
Zeros (%)	6.0%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	467
Q3	2824
95-th percentile	16410.1
Maximum	33060
Range	33060
Interquartile range (IQR)	2824

Descriptive statistics

Standard deviation	5521.497895
Coefficient of variation (CV)	2.075636384
Kurtosis	11.42173549
Mean	2660.146998
Median Absolute Deviation (MAD)	467
Skewness	3.272595409
Sum	1284851
Variance	30486939
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	198	6.0%
467	15	0.5%
3968	10	0.3%
143	7	0.2%
213	7	0.2%
812	6	0.2%
4272	6	0.2%
780	5	0.2%
1199	4	0.1%
542	4	0.1%
Other values (189)	221	6.7%
(Missing)	2832	85.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	198	6.0%
22	1	< 0.1%
109	1	< 0.1%
110	1	< 0.1%
119	1	< 0.1%
133	1	< 0.1%
143	7	0.2%
158	1	< 0.1%
213	7	0.2%
214	2	0.1%

Value	Count	Frequency (%)
33060	1	< 0.1%
32499	1	< 0.1%
30840	1	< 0.1%
30800	1	< 0.1%
29240	1	< 0.1%
28855	1	< 0.1%
26207	1	< 0.1%
25931	1	< 0.1%
25844	1	< 0.1%
25282	1	< 0.1%

prisoner_tests
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1146
Distinct (%)	87.3%
Missing	2002
Missing (%)	60.4%
Infinite	0
Infinite (%)	0.0%
Mean	15819.31379

Minimum	0
Maximum	128746
Zeros	8
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	19.6
Q1	720
median	3676
Q3	17941
95-th percentile	89512.2
Maximum	128746
Range	128746
Interquartile range (IQR)	17221

Descriptive statistics

Standard deviation	26804.34284
Coefficient of variation (CV)	1.694406167
Kurtosis	6.171124142
Mean	15819.31379
Median Absolute Deviation (MAD)	3636
Skewness	2.524820375
Sum	20770759
Variance	718472795
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	0.2%
3676	8	0.2%
5	7	0.2%
17	7	0.2%
34	6	0.2%
14	6	0.2%
10	6	0.2%
15	5	0.2%
27	5	0.2%
723	4	0.1%
Other values (1136)	1251	37.7%
(Missing)	2002	60.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	0.2%
1	3	0.1%
2	2	0.1%
3	3	0.1%
4	4	0.1%
5	7	0.2%
6	1	< 0.1%
7	2	0.1%
8	2	0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
128746	1	< 0.1%
127999	1	< 0.1%
127305	1	< 0.1%
126921	1	< 0.1%
126208	1	< 0.1%
125541	1	< 0.1%
124553	1	< 0.1%
123356	1	< 0.1%
122801	1	< 0.1%
122071	1	< 0.1%

prisoner_tests_with_multiples
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1540
Distinct (%)	96.7%
Missing	1723
Missing (%)	52.0%
Infinite	0
Infinite (%)	0.0%
Mean	61814.40578

Minimum	2
Maximum	978781
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	2
5-th percentile	1425.25
Q1	7647.25
median	23441
Q3	62273.25
95-th percentile	259624.1
Maximum	978781
Range	978779
Interquartile range (IQR)	54626

Descriptive statistics

Standard deviation	117715.6865
Coefficient of variation (CV)	1.904340663
Kurtosis	19.43254406
Mean	61814.40578
Median Absolute Deviation (MAD)	18061
Skewness	4.061564116
Sum	98408534
Variance	1.385698284 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18348	4	0.1%
34006	3	0.1%
6784	3	0.1%
53452	3	0.1%
6782	3	0.1%
315	2	0.1%
3448	2	0.1%
29152	2	0.1%
2282	2	0.1%
33907	2	0.1%
Other values (1530)	1566	47.2%
(Missing)	1723	52.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
11	1	< 0.1%
18	1	< 0.1%
20	1	< 0.1%
65	1	< 0.1%
68	1	< 0.1%
70	1	< 0.1%
74	1	< 0.1%

Value	Count	Frequency (%)
978781	1	< 0.1%
952621	1	< 0.1%
929806	1	< 0.1%
909819	1	< 0.1%
881458	1	< 0.1%
849219	1	< 0.1%
814314	1	< 0.1%
788321	1	< 0.1%
760943	1	< 0.1%
727543	1	< 0.1%

total_prisoner_cases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	2081
Distinct (%)	65.6%
Missing	143
Missing (%)	4.3%
Infinite	0
Infinite (%)	0.0%
Mean	3963.015448

Minimum	0
Maximum	49375
Zeros	164
Zeros (%)	4.9%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	241
median	1399
Q3	4496.25
95-th percentile	16436.1
Maximum	49375
Range	49375
Interquartile range (IQR)	4255.25

Descriptive statistics

Standard deviation	7091.46306
Coefficient of variation (CV)	1.789410905
Kurtosis	17.42187856
Mean	3963.015448
Median Absolute Deviation (MAD)	1388
Skewness	3.788603738
Sum	12570685
Variance	50288848.33
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	164	4.9%
1	52	1.6%
4	41	1.2%
2	40	1.2%
10	17	0.5%
3	15	0.5%
7	15	0.5%
5	14	0.4%
240	14	0.4%
11	12	0.4%
Other values (2071)	2788	84.1%
(Missing)	143	4.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	164	4.9%
1	52	1.6%
2	40	1.2%
3	15	0.5%
4	41	1.2%
5	14	0.4%
6	2	0.1%
7	15	0.5%
8	9	0.3%
9	11	0.3%

Value	Count	Frequency (%)
49375	1	< 0.1%
49356	1	< 0.1%
49324	1	< 0.1%
49298	1	< 0.1%
49254	1	< 0.1%
49237	1	< 0.1%
49229	1	< 0.1%
49221	1	< 0.1%
49215	1	< 0.1%
49214	1	< 0.1%

prisoners_recovered
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	1649
Distinct (%)	73.5%
Missing	1072
Missing (%)	32.3%
Infinite	0
Infinite (%)	0.0%
Mean	4434.114579

Minimum	0
Maximum	48537
Zeros	44
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	440.5
median	1692
Q3	4777.5
95-th percentile	17851.9
Maximum	48537
Range	48537
Interquartile range (IQR)	4337

Descriptive statistics

Standard deviation	7726.994307
Coefficient of variation (CV)	1.74262396
Kurtosis	14.27330405
Mean	4434.114579
Median Absolute Deviation (MAD)	1555
Skewness	3.514692354
Sum	9945719
Variance	59706441.02
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	44	1.3%
4	29	0.9%
1	27	0.8%
10	14	0.4%
2	12	0.4%
238	11	0.3%
5	10	0.3%
8	10	0.3%
633	9	0.3%
27	9	0.3%
Other values (1639)	2068	62.4%
(Missing)	1072	32.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	44	1.3%
1	27	0.8%
2	12	0.4%
3	5	0.2%
4	29	0.9%
5	10	0.3%
6	2	0.1%
7	6	0.2%
8	10	0.3%
9	3	0.1%

Value	Count	Frequency (%)
48537	1	< 0.1%
48460	1	< 0.1%
48456	1	< 0.1%
48404	1	< 0.1%
48396	1	< 0.1%
48395	1	< 0.1%
48390	1	< 0.1%
48386	1	< 0.1%
48382	1	< 0.1%
48379	1	< 0.1%

total_prisoner_deaths
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	203
Distinct (%)	6.4%
Missing	131
Missing (%)	4.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.26853015

Minimum	0
Maximum	273
Zeros	715
Zeros (%)	21.6%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	10.5
Q3	38
95-th percentile	136
Maximum	273
Range	273
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	50.08219887
Coefficient of variation (CV)	1.654596329
Kurtosis	8.004226527
Mean	30.26853015
Median Absolute Deviation (MAD)	10.5
Skewness	2.753307714
Sum	96375
Variance	2508.226644
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	715	21.6%
1	165	5.0%
2	136	4.1%
3	98	3.0%
6	96	2.9%
4	87	2.6%
7	72	2.2%
8	69	2.1%
13	68	2.1%
5	68	2.1%
Other values (193)	1610	48.6%
(Missing)	131	4.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	715	21.6%
1	165	5.0%
2	136	4.1%
3	98	3.0%
4	87	2.6%
5	68	2.1%
6	96	2.9%
7	72	2.2%
8	69	2.1%
9	46	1.4%

Value	Count	Frequency (%)
273	13	0.4%
271	2	0.1%
270	1	< 0.1%
268	1	< 0.1%
267	1	< 0.1%
260	1	< 0.1%
256	2	0.1%
255	2	0.1%
253	2	0.1%
252	2	0.1%

prisoners_partial_dose
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	426
Distinct (%)	53.8%
Missing	2523
Missing (%)	76.1%
Infinite	0
Infinite (%)	0.0%
Mean	4697.820707

Minimum	0
Maximum	70794
Zeros	283
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	802
Q3	4670.5
95-th percentile	18394.95
Maximum	70794
Range	70794
Interquartile range (IQR)	4670.5

Descriptive statistics

Standard deviation	10181.72401
Coefficient of variation (CV)	2.167329203
Kurtosis	22.18288773
Mean	4697.820707
Median Absolute Deviation (MAD)	802
Skewness	4.338825928
Sum	3720674
Variance	103667503.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	283	8.5%
197	9	0.3%
574	6	0.2%
2164	6	0.2%
729	5	0.2%
10844	4	0.1%
803	4	0.1%
4362	4	0.1%
3938	4	0.1%
358	3	0.1%
Other values (416)	464	14.0%
(Missing)	2523	76.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	283	8.5%
8	2	0.1%
30	1	< 0.1%
40	1	< 0.1%
79	1	< 0.1%
82	1	< 0.1%
90	1	< 0.1%
100	1	< 0.1%
104	1	< 0.1%
109	2	0.1%

Value	Count	Frequency (%)
70794	1	< 0.1%
70374	1	< 0.1%
69946	1	< 0.1%
69798	1	< 0.1%
69165	1	< 0.1%
68107	1	< 0.1%
67658	1	< 0.1%
66823	1	< 0.1%
66601	1	< 0.1%
65728	1	< 0.1%

prisoners_full_dose
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	293
Distinct (%)	42.5%
Missing	2625
Missing (%)	79.2%
Infinite	0
Infinite (%)	0.0%
Mean	4677.82029

Minimum	0
Maximum	78858
Zeros	339
Zeros (%)	10.2%
Negative	0
Negative (%)	0.0%
Memory size	26.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	87
Q3	3585
95-th percentile	20118
Maximum	78858
Range	78858
Interquartile range (IQR)	3585

Descriptive statistics

Standard deviation	11762.40905
Coefficient of variation (CV)	2.514506398
Kurtosis	17.26355825
Mean	4677.82029
Median Absolute Deviation (MAD)	87
Skewness	3.971358369
Sum	3227696
Variance	138354266.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	339	10.2%
18895	10	0.3%
284	6	0.2%
8734	4	0.1%
723	4	0.1%
197	4	0.1%
1011	4	0.1%
537	4	0.1%
4279	3	0.1%
4401	3	0.1%
Other values (283)	309	9.3%
(Missing)	2625	79.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	339	10.2%
2	1	< 0.1%
14	1	< 0.1%
26	1	< 0.1%
82	1	< 0.1%
85	2	0.1%
89	1	< 0.1%
92	1	< 0.1%
106	1	< 0.1%
110	1	< 0.1%

Value	Count	Frequency (%)
78858	1	< 0.1%
75676	1	< 0.1%
73050	1	< 0.1%
69181	1	< 0.1%
68805	1	< 0.1%
68111	1	< 0.1%
67481	1	< 0.1%
67329	1	< 0.1%
66555	1	< 0.1%
65626	1	< 0.1%

as_of_date
Categorical

HIGH CARDINALITY

Distinct	353
Distinct (%)	10.7%
Missing	28
Missing (%)	0.8%
Memory size	26.0 KiB

03/26/2020	47
04/01/2020	46
10/20/2020	44
05/20/2020	44
08/18/2020	44
Other values (348)	3062

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	32870
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	102 ?
Unique (%)	3.1%

Sample

1st row	06/16/2021
2nd row	06/15/2021
3rd row	06/16/2021
4th row	06/15/2021
5th row	06/16/2021

Common Values

Value	Count	Frequency (%)
03/26/2020	47	1.4%
04/01/2020	46	1.4%
10/20/2020	44	1.3%
05/20/2020	44	1.3%
08/18/2020	44	1.3%
12/22/2020	43	1.3%
05/13/2020	43	1.3%
04/15/2020	42	1.3%
09/08/2020	42	1.3%
04/22/2020	42	1.3%
Other values (343)	2850	86.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
03/26/2020	47	1.4%
04/01/2020	46	1.4%
08/18/2020	44	1.3%
10/20/2020	44	1.3%
05/20/2020	44	1.3%
05/13/2020	43	1.3%
12/22/2020	43	1.3%
04/15/2020	42	1.3%
04/22/2020	42	1.3%
01/05/2021	42	1.3%
Other values (343)	2850	86.7%

Most occurring characters

Value	Count	Frequency (%)
0	9591	29.2%
2	8506	25.9%
/	6574	20.0%
1	3598	10.9%
6	769	2.3%
3	752	2.3%
5	727	2.2%
4	708	2.2%
9	599	1.8%
8	553	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26296	80.0%
Other Punctuation	6574	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	9591	36.5%
2	8506	32.3%
1	3598	13.7%
6	769	2.9%
3	752	2.9%
5	727	2.8%
4	708	2.7%
9	599	2.3%
8	553	2.1%
7	493	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	6574	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	32870	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	9591	29.2%
2	8506	25.9%
/	6574	20.0%
1	3598	10.9%
6	769	2.3%
3	752	2.3%
5	727	2.2%
4	708	2.2%
9	599	1.8%
8	553	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32870	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	9591	29.2%
2	8506	25.9%
/	6574	20.0%
1	3598	10.9%
6	769	2.3%
3	752	2.3%
5	727	2.2%
4	708	2.2%
9	599	1.8%
8	553	1.7%

notes
Categorical

HIGH CARDINALITY
MISSING

Distinct	597
Distinct (%)	45.5%
Missing	2002
Missing (%)	60.4%
Memory size	26.0 KiB

We have been told vaccinations have begun in this system, but they have not released numbers for this week.	100
The number of tested people was mistakenly placed in the column for the total number of tests. This has been updated.	62
The number of recovered prisoners was updated. An earlier version included the numbers of deaths in the recovered count.	30
The number of tests conducted was mistakenly placed in the column for people tested. This has been updated.	27
Missouri's total cases omitted deaths and has been updated.	25
Other values (592)	1069

Length

Max length	867
Median length	119
Mean length	175.0792079
Min length	17

Characters and Unicode

Total characters	229879
Distinct characters	83
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	499 ?
Unique (%)	38.0%

Sample

1st row	We have been told vaccinations have begun in this system, but they have not released numbers of people vaccinated for this week. The number of recovered prisoners was updated. An earlier version included the numbers of deaths in the recovered count.
2nd row	Vaccines as of 6/16
3rd row	Vaccines as of 6/18. 8329 prisoners received the one-shot Johnson & Johnson vaccine and were fully vaccinated.
4th row	4191 prisoners have received the one-shot Johnson & Johnson vaccine. We remove 38 presumed positives from the recovered prisoners each week
5th row	The vaccination numbers now include prisoners who have been released after being vaccinated and thus may appear to be a larger growth than it should. 25,850 prisoners have been fully vaccinated with the one-shot Johnson & Johnson vaccine. The state is also no longer reporting cases in community corrections, so we are adding in the last known number of cases there, 309. As a result, these case numbers are almost certainly an undercount.

Common Values

Value	Count	Frequency (%)
We have been told vaccinations have begun in this system, but they have not released numbers for this week.	100	3.0%
The number of tested people was mistakenly placed in the column for the total number of tests. This has been updated.	62	1.9%
The number of recovered prisoners was updated. An earlier version included the numbers of deaths in the recovered count.	30	0.9%
The number of tests conducted was mistakenly placed in the column for people tested. This has been updated.	27	0.8%
Missouri's total cases omitted deaths and has been updated.	25	0.8%
In early January 2020, North Dakota's Department of Corrections and Rehabilitation revised its testing figures, back to the beginning of the pandemic. We have updated our figures here accordingly.	25	0.8%
For most weeks prior to Sept. 15, the prisoner cases and recoveries for Georgia inadvertently counted some cases in private prisons and county facilities twice. These figures have been corrected throughout.	21	0.6%
Until early November, West Virginia’s Department of Corrections and Rehabilitation reported staff cases for juvenile facilities and jails combined with prisons and work release. After they began providing itemized numbers on staff cases on Nov. 3, we only included staff numbers from prisons and work release sites in our data releases. In our online tracker, we have gone back to the past weeks of data and estimated the staff breakdown based on the overall size of the staff for each sector.	21	0.6%
The number of tests conducted was mistakenly placed in the column for the total number of people tested. This has been updated.	19	0.6%
In May 2021, New Jersey's Department of Corrections revised much of its historic data for tests and cases among prisoners and staff. These figures revealed many new cases but also exclude prisoner cases in residential community release programs that were reported prior to August of 2020, including one death. We have retained the one death in a reentry center, but otherwise are now reporting only data for prisons. We have updated this week accordingly. We have been told vaccinations have begun in this system this week, but they have not released numbers.	18	0.5%
Other values (587)	965	29.1%
(Missing)	2002	60.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	1733	4.6%
of	1243	3.3%
have	961	2.6%
in	957	2.6%
this	860	2.3%
and	854	2.3%
to	692	1.8%
for	664	1.8%
staff	638	1.7%
been	628	1.7%
Other values (1302)	28247	75.4%

Most occurring characters

Value	Count	Frequency (%)
	36193	15.7%
e	27736	12.1%
t	15361	6.7%
s	14368	6.3%
a	13308	5.8%
n	13045	5.7%
r	12356	5.4%
o	12275	5.3%
i	11536	5.0%
d	8157	3.5%
Other values (73)	65544	28.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	180675	78.6%
Space Separator	36194	15.7%
Uppercase Letter	5117	2.2%
Other Punctuation	4628	2.0%
Decimal Number	2771	1.2%
Dash Punctuation	256	0.1%
Connector Punctuation	70	< 0.1%
Open Punctuation	55	< 0.1%
Close Punctuation	55	< 0.1%
Final Punctuation	35	< 0.1%
Other values (2)	23	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	27736	15.4%
t	15361	8.5%
s	14368	8.0%
a	13308	7.4%
n	13045	7.2%
r	12356	6.8%
o	12275	6.8%
i	11536	6.4%
d	8157	4.5%
h	7265	4.0%
Other values (16)	45268	25.1%

Uppercase Letter

Value	Count	Frequency (%)
T	904	17.7%
W	488	9.5%
I	462	9.0%
J	444	8.7%
A	406	7.9%
C	376	7.3%
D	331	6.5%
S	287	5.6%
N	233	4.6%
O	229	4.5%
Other values (14)	957	18.7%

Other Punctuation

Value	Count	Frequency (%)
.	2492	53.8%
,	1215	26.3%
'	442	9.6%
/	257	5.6%
"	98	2.1%
&	96	2.1%
:	19	0.4%
*	5	0.1%
%	3	0.1%
;	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	657	23.7%
1	595	21.5%
0	417	15.0%
3	253	9.1%
4	195	7.0%
5	165	6.0%
8	144	5.2%
9	141	5.1%
6	114	4.1%
7	90	3.2%

Dash Punctuation

Value	Count	Frequency (%)
-	254	99.2%
—	1	0.4%
–	1	0.4%

Math Symbol

Value	Count	Frequency (%)
=	8	47.1%
+	8	47.1%
>	1	5.9%

Space Separator

Value	Count	Frequency (%)
	36193	> 99.9%
	1	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	55	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	55	100.0%

Control

Value	Count	Frequency (%)
	6	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	70	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	35	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	185792	80.8%
Common	44087	19.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	27736	14.9%
t	15361	8.3%
s	14368	7.7%
a	13308	7.2%
n	13045	7.0%
r	12356	6.7%
o	12275	6.6%
i	11536	6.2%
d	8157	4.4%
h	7265	3.9%
Other values (40)	50385	27.1%

Common

Value	Count	Frequency (%)
	36193	82.1%
.	2492	5.7%
,	1215	2.8%
2	657	1.5%
1	595	1.3%
'	442	1.0%
0	417	0.9%
/	257	0.6%
-	254	0.6%
3	253	0.6%
Other values (23)	1312	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	229841	> 99.9%
Punctuation	37	< 0.1%
Latin 1 Sup	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	36193	15.7%
e	27736	12.1%
t	15361	6.7%
s	14368	6.3%
a	13308	5.8%
n	13045	5.7%
r	12356	5.4%
o	12275	5.3%
i	11536	5.0%
d	8157	3.5%
Other values (69)	65506	28.5%

Punctuation

Value	Count	Frequency (%)
’	35	94.6%
—	1	2.7%
–	1	2.7%

Latin 1 Sup

Value	Count	Frequency (%)
	1	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	name	abbreviation	staff_tests	staff_tests_with_multiples	total_staff_cases	staff_recovered	total_staff_deaths	staff_partial_dose	staff_full_dose	prisoner_tests	prisoner_tests_with_multiples	total_prisoner_cases	prisoners_recovered	total_prisoner_deaths	prisoners_partial_dose	prisoners_full_dose	as_of_date	notes
0	Alabama	AL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	Alaska	AK	NaN	NaN	332.0	NaN	0.0	NaN	NaN	NaN	38148.0	NaN	NaN	5.0	NaN	NaN	06/16/2021	NaN
2	Arizona	AZ	NaN	NaN	2785.0	2773.0	NaN	NaN	NaN	47758.0	NaN	12326.0	12246.0	64.0	NaN	NaN	06/15/2021	NaN
3	Arkansas	AR	NaN	NaN	NaN	NaN	4.0	NaN	NaN	NaN	NaN	11416.0	11388.0	52.0	NaN	NaN	06/16/2021	We have been told vaccinations have begun in this system, but they have not released numbers of people vaccinated for this week. The number of recovered prisoners was updated. An earlier version included the numbers of deaths in the recovered count.
4	California	CA	NaN	NaN	17002.0	16941.0	28.0	35115.0	33060.0	128746.0	NaN	49375.0	48460.0	224.0	70794.0	68805.0	06/15/2021	NaN
5	Colorado	CO	NaN	NaN	1948.0	NaN	0.0	3618.0	NaN	20591.0	230798.0	8960.0	NaN	29.0	10541.0	NaN	06/16/2021	NaN
6	Connecticut	CT	NaN	86292.0	1690.0	1686.0	0.0	2697.0	NaN	NaN	138227.0	4546.0	4503.0	19.0	4828.0	NaN	06/15/2021	NaN
7	Delaware	DE	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	Florida	FL	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	Georgia	GA	NaN	NaN	1745.0	1723.0	4.0	1650.0	NaN	NaN	NaN	3869.0	3768.0	93.0	26569.0	NaN	06/15/2021	NaN

Last rows

	name	abbreviation	staff_tests	staff_tests_with_multiples	total_staff_cases	staff_recovered	staff_partial_dose	staff_full_dose	prisoner_tests	prisoner_tests_with_multiples	total_prisoner_cases	prisoners_recovered	prisoners_partial_dose	prisoners_full_dose	as_of_date	notes
3305	Tennessee	TN	0.0	NaN	0.0	NaN	NaN	NaN	0.0	NaN	0.0	NaN	NaN	NaN	03/26/2020	NaN
3306	Texas	TX	NaN	NaN	2.0	NaN	NaN	NaN	25.0	NaN	1.0	NaN	NaN	NaN	03/26/2020	25 tested = 15 pending, 1 positive, 9 negative.
3307	Utah	UT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	NaN	NaN	03/26/2020	NaN
3308	Vermont	VT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.0	NaN	NaN	NaN	03/26/2020	NaN
3309	Virginia	VA	NaN	NaN	0.0	NaN	NaN	NaN	2.0	NaN	0.0	NaN	NaN	NaN	03/26/2020	NaN
3310	Washington	WA	NaN	NaN	4.0	NaN	NaN	NaN	71.0	NaN	0.0	NaN	NaN	NaN	03/26/2020	NaN
3311	West Virginia	WV	NaN	NaN	0.0	NaN	NaN	NaN	NaN	NaN	0.0	NaN	NaN	NaN	03/26/2020	back-filled data based on 4/1 responses. Until early November, West Virginia’s Department of Corrections and Rehabilitation reported staff cases for juvenile facilities and jails combined with prisons and work release. After they began providing itemized numbers on staff cases on Nov. 3, we only included staff numbers from prisons and work release sites in our data releases. In our online tracker, we have gone back to the past weeks of data and estimated the staff breakdown based on the overall size of the staff for each sector.
3312	Wisconsin	WI	NaN	NaN	5.0	NaN	NaN	NaN	NaN	NaN	0.0	NaN	NaN	NaN	03/26/2020	staff cases include those in adult institution + community corrections
3313	Wyoming	WY	0.0	NaN	0.0	NaN	NaN	NaN	0.0	NaN	0.0	NaN	NaN	NaN	03/26/2020	NaN
3314	Federal	US	NaN	NaN	8.0	NaN	NaN	NaN	NaN	NaN	10.0	NaN	NaN	NaN	03/26/2020	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Dash Punctuation

Math Symbol

Space Separator

Open Punctuation

Close Punctuation

Control

Connector Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

Latin 1 Sup

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows